Bug Repoprt- Casting Issues - Mailing list pgsql-bugs

From Dirk Elmendorf
Subject Bug Repoprt- Casting Issues
Date
Msg-id p0431011eb55c7a3d9cb8@[64.39.0.239]
Whole thread Raw
Responses Re: Bug Repoprt- Casting Issues  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
============================================================================
                         POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        :    Dirk Elmendorf
Your email address    : delmendo@rackspace.com


System Configuration
---------------------
   Architecture (example: Intel Pentium)      : Intel Pentium

   Operating System (example: Linux 2.0.26 ELF)     :RedHat Linux 6.1/ 2.2.12-20
   PostgreSQL version (example: PostgreSQL-6.5.1):   PostgreSQL-7.0
   Compiler used (example:  gcc 2.8.0)        :    egcs-2.9.66


Please enter a FULL description of your problem:
------------------------------------------------
Casting system was changed.
Cannot cast and int4 to a date using the :: or cast as syntax to cast
an int4 to a date.


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
create table test
(
    seconds int4
);

insert into test (seconds) values(951414912);

select seconds::date from test;
ERROR: Cannot casty type 'int4' to 'date'


select date(seconds) from test;
date
--------
200-02-24





If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------


--
______________________________________________________________________
Dirk Elmendorf, CTE                                Main: 210-892-4000
Rackspace,Ltd.                                   Direct: 210-892-4005
Weston Center                                       Fax: 210-892-4329
112 East Pecan, Suite 600                Email:delmendo@rackspace.com
San Antonio,  TX 78205                     <http://www.rackspace.com>

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: INET operators and NOT
Next
From: Tom Lane
Date:
Subject: Re: Bug Repoprt- Casting Issues